Amazon review analysis

Sentiment Analysis

Perform EDA for the Positive Sentences

(-0.5, 999.5, 499.5, -0.5)

Perform EDA for the Negative Sentences

(-0.5, 999.5, 499.5, -0.5)

To what User Amazon can recommend more product?

Summary Text Score ProductId
UserId
#oc-R103C0QSV1DF5E 1 1 5.000000 1
#oc-R109MU5OBBZ59U 1 1 5.000000 1
#oc-R10LFEMQEW6QGZ 1 1 5.000000 1
#oc-R10LT57ZGIB140 1 1 3.000000 1
#oc-R10UA029WVWIUI 1 1 1.000000 1
... ... ... ... ...
AZZV9PDNMCOZW 3 3 4.666667 3
AZZVNIMTTMJH6 1 1 5.000000 1
AZZY649VYAHQS 1 1 5.000000 1
AZZYCJOJLUDYR 1 1 5.000000 1
AZZZOVIBXHGDR 1 1 2.000000 1

256059 rows × 4 columns

([0, 1, 2, 3, 4, 5, 6, 7, 8, 9], <a list of 10 Text xticklabel objects>)

Analyze length of comments -whether Customers are going to give lengthy comment or short one

/opt/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """Entry point for launching an IPython kernel.
Requirement already satisfied: plotly in /opt/anaconda3/lib/python3.7/site-packages (4.14.3)
Requirement already satisfied: six in /opt/anaconda3/lib/python3.7/site-packages (from plotly) (1.14.0)
Requirement already satisfied: retrying>=1.3.3 in /opt/anaconda3/lib/python3.7/site-packages (from plotly) (1.3.3)
Note: you may need to restart the kernel to use updated packages.

Analyzing Score

<matplotlib.axes._subplots.AxesSubplot at 0x7fd38067deb0>

Analyzing behaviour of customer

'seriously product tasteless come much better tasting products 100 calories better special k bar cookie snack pack season combine something else share flavor '

Check if URLs is present in Text column or not

'bought husband currently overseas loves apparently staff likes alsobr generous amounts twizzlers 16ounce bag well worth price hrefhttpwwwamazoncomgpproductb001gvisjmtwizzlers strawberry 16ounce bags pack 6a'
'bought husband currently overseas loves apparently staff likes alsobr generous amounts twizzlers 16ounce bag well worth price  strawberry 16ounce bags pack 6a'
(-0.5, 799.5, 799.5, -0.5)
[NbConvertApp] Converting notebook Amazon_review_analysis_html.ipynb to html
[NbConvertApp] Writing 4684243 bytes to Amazon_review_analysis_html.html